<?php
header("Content-type:text/html;charset=utf-8");
$conn =@mysql_connect('localhost','root','')
or die('数据库无法连接！');
@mysql_select_db('neu-video',$conn)
or die('数据库不存在！');
mysql_set_charset("utf8");
$sql ='select *from users';
$result =mysql_query($sql,$conn);
/*while ($result&&($row =mysql_fetch_assoc)!==FALSE){
echo $row['uname'].'<br>';

}
*/

$arrs=fetch_array($result);
var_dump($arrs);
echo '<table border="1">';
echo '<caption>用户管理</caption>';
echo '<tr>
<th>序号</th>
<th>用户名</th>
<th>性别</th>
<th>爱好</th>
</tr>';
foreach ($arrs as $index=>$one) {
	echo '<tr>';
	echo '<td>'.($index+1).'</td>';
	echo '<td>'.$one['uname'].'</td>';
    if($one['gender']==1){$sex='男';}
    	else{$sex='女';}
	echo '<td>'.$sex.'</td>';
	echo '<td>'.$one['hobby'].'</td>';
	echo '</tr>';
}

echo '</table>';

function fetch_array($Results){
    $arrs = array();
  while ($Results &&($row =mysql_fetch_assoc($Results))!==FALSE){
  	$arrs[]=$row;
  }


	return $arrs;
}
?>  